Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerDeliveryID (FK)(PK) | A TOKEN identifier for a CustomerDelivery entity type instance. | ID_CT_DV | Identity | integer | CustomerDeliveryInstruction(CO_CT_DV_INSTR) |
CustomerDeliverySequenceNumber (PK) | A sequence number used to distinguish specific ship to instructions associated with a CustomerDelivery. As an example, Walmart's Web store allows a customer to specifiy multiple delivery preferences for an order so one order and delivery can be split into multiple different destinations, ship times, etc. | IC_CT_DV_SQN_NMB | LineNumber | smallint | |
RequestedDeliveryDate | Requested delivery date to define the day a customer wants goods in an order delivered. | TS_DV_PRFC | DateCalendar | datetime | |
SpecialInstructions | Narrative text, giving special delivery instructions that apply only to this specific CustomerDeliveryPreference. This is used in scenarios where a customer order specifies that in addition to | NA_INST_SPL | DescriptionNarrative | varchar(4000) | |
RequestedDeliveryTo (FK) | A token identifier for a PartyContactMethod entity type instance. | ID_PRTY_CNCT_MTH | Identity | integer | PartyContactMethod(CO_MTH_CNCT_PTY) |
PrimaryDeliverBeforeAfterCode | Indicates if the preferred delivery time is before DeliverTime or after DeliverTime. Sample values: BEFORE AFTER | CD_DV_BFR_OR_AFT | Code | varchar(20) | |
PrimaryDeliverTime | Preferred time of day for a delivery to occur on the RequestedDeliveryDate specified in CustomerDeliveryPreference. | DT_DV_PRFC | Time | datetime | |
SecondaryDeliverTime | Secondary preference for a delivery time if the primary delivery time is not available. | DT_SCNDRY_DV_TM | Time | datetime | |
SecondaryDeliverBeforeAfterCode | Indicates if the preferred delivery time is before SecondaryDeliverTime or after SecondaryDeliverTime. Sample values: BEFORE AFTER | CD_SCNDRY_DV_BFR_AFT | Code | varchar(20) | |